2016-06-09 - 27413 - Spec - New report field investigation #CrystalReportDevelopment

SPECIFICATIONS

27413 - New report field investigation

Purpose

Need to create new customer report and also investigate and find the list of fields available in BW for customer and incoterm reports.

Admin Info

Purpose	Need to create new customer report and also investigate and find the list of fields available in BW for customer and incoterm reports.
Requested By	Judy Sanchez
Spec Created By	Dhananjaya
Spec Created Date	06-14-2016
Spec QA by	Uday P
Objects	ZMP_OOCON_Customer_Test
Document Status	Complete

Estimates

SNo	Activity	Estimation in Hours
1	Research	20
2	Documentation	10
3	Development/ Config	30
4	Unit test in DEV	05
5	Unit test in QUA	05
6	Other activity	00
	TOTAL	70

References

Prior Tickets

None

Documents
None

Spec Changes

SNo	Change Details	Requested By	Requested On	Notes if any

Functional Requirement

Purpose/WHY:

Need to investigate and find the list of fields available in BW for customer and incoterm reports.

In Scope:

Need to create new customer report with available fields in BW as required.

Out of Scope:
Some of the fields are not available in BW.

Solution Summary

Customer Report:
1. Need to create the report with available fields in BW source.
2. Need to create the input parameter for Sales rep.
3. Need to write the filter condition to get the data based on input parameter Sales rep.

Test Plan

Test ID	Test Scenario	Expected Results
1	Report Format.	Should be as per NEC crystal standard checklist.
2	Execute Crystal Report in Crystal Designer tool after changes.	Report should execute successfully in Crystal Designer tool.
3	Schedule the Report in NEC BI Launch Pad.	Report should execute successfully in NEC BI Launch Pad.

Incoterms Report:
Cannot be designed based on BW sources as the fields are not available.

Solution Details

Issues

Incoterms Report cannot be designed based on BW sources as the fields are not available.